﻿
CREATE PROCEDURE [svc].[GetSessionLogAverageAndMaxWriteTime]
(
	@FromDate				datetime,
	@ToDate					datetime 
)
AS
BEGIN


SELECT MAX(Writes) AS MaxWriteTime, AVG(Writes) *100 / MAX(Writes) AS AverageWriteTime 
FROM dbo.ExecSessionLog 
WHERE LastModifiedDate BETWEEN @FromDate AND @ToDate 

END